home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vbillcoins.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
613b
|
19 lines
CREATE OR REPLACE VIEW vbillcoins AS
SELECT ALARMACT.DET_SEQ_NUM ,
CONV_DATE,
ALARMACT.alarm_id alarm,
0 curr_type, '01' table_code
FROM ALARMACT
WHERE TRUNC(conv_date) > '01-JAN-2000' AND ALARMACT.alarm_id
IN (22, 23, 24, 25, 26, 34 )
UNION
SELECT CMDINIT.DET_SEQ_NUM, CONV_DATE,
CMDINIT.command_id alarm, 0 curr_type,'12' table_code
FROM CMDINIT
WHERE TRUNC(conv_date) > '01-JAN-2000' AND CMDINIT.command_id =9
UNION
SELECT CURACC.DET_SEQ_NUM, CONV_DATE,
0 alarm, FLOOR(0.01 * currency_type) curr_type, '16' table_code
FROM CURACC
WHERE TRUNC(conv_date) > '01-JAN-2000'